inherited dtmck_ProductStockSum: Tdtmck_ProductStockSum
  OldCreateOrder = True
  Left = 405
  Top = 332
  Height = 414
  Width = 659
  inherited adsMaster: TADODataSet
    CursorType = ctStatic
    CommandText = 
      'Exec ck_rpt_ProductStockSum'#13#10'@BeginDate=:BeginDate,'#13#10'@EndDate=:E' +
      'ndDate,'#13#10'@DeptID=:DeptID,'#13#10'@StockID=:StockID,'#13#10'@ProductCode=:Pro' +
      'ductCode'
    Parameters = <
      item
        Name = 'BeginDate'
        Attributes = [paNullable]
        DataType = ftDateTime
        NumericScale = 3
        Precision = 23
        Size = 16
        Value = Null
      end
      item
        Name = 'EndDate'
        Attributes = [paNullable]
        DataType = ftDateTime
        NumericScale = 3
        Precision = 23
        Size = 16
        Value = Null
      end
      item
        Name = 'DeptID'
        Attributes = [paNullable]
        DataType = ftString
        NumericScale = 255
        Precision = 255
        Size = 20
        Value = Null
      end
      item
        Name = 'StockID'
        Attributes = [paNullable]
        DataType = ftString
        NumericScale = 255
        Precision = 255
        Size = 20
        Value = Null
      end
      item
        Name = 'ProductCode'
        Attributes = [paNullable]
        DataType = ftString
        NumericScale = 255
        Precision = 255
        Size = 20
        Value = Null
      end>
    object adsMasterRuleChildID: TStringField
      DisplayLabel = #35268#21017'ID'
      FieldName = 'RuleChildID'
      ReadOnly = True
      Size = 50
    end
    object adsMasterProductCode: TStringField
      DisplayLabel = #20135#21697#32534#30721
      FieldName = 'ProductCode'
      Size = 50
    end
    object adsMasterProductName: TStringField
      DisplayLabel = #20135#21697#21517#31216
      FieldName = 'ProductName'
      Size = 100
    end
    object adsMasterSpecs: TStringField
      DisplayLabel = #22411#21495#35268#26684
      FieldName = 'Specs'
      ReadOnly = True
      Size = 200
    end
    object adsMasterBeginPieceCount: TFloatField
      DisplayLabel = #19978#26399#32467#23384'|'#21305#25968
      FieldName = 'BeginPieceCount'
      ReadOnly = True
    end
    object adsMasterBeginNumber: TFloatField
      DisplayLabel = #19978#26399#32467#23384'|'#25968#37327
      FieldName = 'BeginNumber'
      ReadOnly = True
    end
    object adsMasterBeginMoney: TFloatField
      DisplayLabel = #19978#26399#32467#23384'|'#37329#39069
      FieldName = 'BeginMoney'
      ReadOnly = True
    end
    object adsMasterInPieceCount: TFloatField
      DisplayLabel = #26412#26399#25910#20837'|'#21305#25968
      FieldName = 'InPieceCount'
      ReadOnly = True
    end
    object adsMasterInNumber: TFloatField
      DisplayLabel = #26412#26399#25910#20837'|'#25968#37327
      FieldName = 'InNumber'
      ReadOnly = True
    end
    object adsMasterInMoney: TFloatField
      DisplayLabel = #26412#26399#25910#20837'|'#37329#39069
      FieldName = 'InMoney'
    end
    object adsMasterOutPieceCount: TFloatField
      DisplayLabel = #26412#26399#21457#20986'|'#21305#25968
      FieldName = 'OutPieceCount'
      ReadOnly = True
    end
    object adsMasterOutNumber: TFloatField
      DisplayLabel = #26412#26399#21457#20986'|'#25968#37327
      FieldName = 'OutNumber'
      ReadOnly = True
    end
    object adsMasterOutMoney: TFloatField
      DisplayLabel = #26412#26399#21457#20986'|'#37329#39069
      FieldName = 'OutMoney'
    end
    object adsMasterTotalPieceCount: TFloatField
      DisplayLabel = #26412#26399#32467#23384'|'#21305#25968
      FieldName = 'TotalPieceCount'
      ReadOnly = True
    end
    object adsMasterTotalNumber: TFloatField
      DisplayLabel = #26412#26399#32467#23384'|'#25968#37327
      FieldName = 'TotalNumber'
      ReadOnly = True
    end
    object adsMasterTotalMoney: TFloatField
      DisplayLabel = #26412#26399#32467#23384'|'#37329#39069
      FieldName = 'TotalMoney'
      ReadOnly = True
    end
    object adsMasterUnitID: TStringField
      DisplayLabel = #21333#20301'ID'
      FieldName = 'UnitID'
      ReadOnly = True
    end
    object adsMasterUnitName: TStringField
      DisplayLabel = #21333#20301
      FieldName = 'UnitName'
      ReadOnly = True
      Size = 10
    end
  end
  inherited adsMasterEdit: TADODataSet
    CursorType = ctStatic
  end
  object adsUserCompany: TADODataSet
    Connection = dtmConnect.conMain
    LockType = ltBatchOptimistic
    CommandText = 
      'select b.DeptID, b.DeptCode, b.DeptName from xt_CompanySet a '#13#10'j' +
      'oin da_Department b on a.CompanyID=b.DeptID'#13#10'where a.UserID=(sel' +
      'ect UserID from xt_Users where UserCode=:UserCode)'
    Parameters = <
      item
        Name = 'UserCode'
        Size = -1
        Value = Null
      end>
    Left = 176
    Top = 104
  end
  object adsUserStock: TADODataSet
    Connection = dtmConnect.conMain
    LockType = ltBatchOptimistic
    CommandText = 
      'select b.StockID, b.StockCode, b.StockName from xt_StockSet a '#13#10 +
      'join da_Stock b on a.StockID=b.StockID'#13#10'where b.DeptID=:DeptID'#13#10 +
      ' and a.UserID=(select UserID from xt_Users where UserCode=:UserC' +
      'ode)'#13#10' and isnull(b.StockType,0)=12 and isnull(b.HasStop,0)=0'
    Parameters = <
      item
        Name = 'DeptID'
        DataType = ftString
        NumericScale = 255
        Precision = 255
        Size = 20
        Value = Null
      end
      item
        Name = 'UserCode'
        Size = -1
        Value = Null
      end>
    Left = 176
    Top = 40
  end
  object adsProductType: TADODataSet
    Connection = dtmConnect.conMain
    CursorType = ctStatic
    LockType = ltBatchOptimistic
    CommandText = 'select * from V_da_ProductType order by RuleChildID'
    Parameters = <>
    Left = 176
    Top = 168
  end
end
